# coding: utf-8
# from flask_sqlalchemy import SQLAlchemy
#
#
# db = SQLAlchemy()
from application import db



class User(db.Model):
    __tablename__ = 'user'

    id = db.Column(db.Integer, primary_key=True)
    login_name = db.Column(db.String(20, 'utf8mb4_0900_ai_ci'), nullable=False, unique=True)
    login_pwd = db.Column(db.String(32, 'utf8mb4_0900_ai_ci'), nullable=False)
    login_salt = db.Column(db.String(32, 'utf8mb4_0900_ai_ci'), nullable=False)
    status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
